<?php

defined('BASEPATH') or exit('No direct script access allowed');

/**
 * @property CI_DB_forge         $dbforge
 * @property CI_DB_query_builder $db
 */
class Migration_create_pages extends CI_Migration
{
    public function up()
    {
        $this->dbforge->add_field(array(
            'id'           => array(
                'type'           => 'INT',
                'constraint'     => '10',
                'unsigned'       => true,
                'auto_increment' => true
            ),
            'title'        => array(
                'type'       => 'VARCHAR',
                'constraint' => '100'
            ),
            'uri_friendly' => array(
                'type'       => 'VARCHAR',
                'constraint' => '100'
            ),
            'description'  => array(
                'type' => 'TEXT',
                'null' => false
            ),
            'date'         => array(
                'type'       => 'INT',
                'constraint' => '10',
                'unsigned'   => true,
                'default'    => '0'
            ),
        ));
        $this->dbforge->add_key('id', true);
        $this->dbforge->create_table('pages');

        $data = array(
            'title'        => 'Terms of Use',
            'uri_friendly' => 'terms-of-use',
            'description'  => '<h1 id="h_6174560082761658239187001"><span style="color: #f8b700;"><a style="color: #f8b700;" title="Terms of Use Agreement" href="#h_6174560082761658239187001">#</a></span> Terms of Use Agreement <!--?php echo "hello" ?--></h1><hr><p>This agreement sets forth the terms and conditions under which you are bound by when registering or connecting to any YesilCMS PTR service.</p><p>If you feel a player has violated this agreement, please report them with the corresponding system.</p><h2 id="h_69792590132121658239401357"><span style="color: #f8b700;"><a style="color: #f8b700;" title="Code of Conduct" href="#h_69792590132121658239401357">#</a></span> I. Code of Conduct</h2><hr><p>The guidelines and rules listed below explain what behaviour is expected of you and what behaviour you can expect from other users both in-game and on the forum. Note that the following guidelines are not exhaustive, and may not address all manner of offensive behaviour.</p><p>While using any YesilCMS PTR service, you will encounter a large number of users who share different experiences and come from different backgrounds. While certain language and images may not be offensive to you, consider the fact that the same language and images may have a completely different effect on someone else.</p><p><strong>All users on YesilCMS PTR must adhere to these rules. Violations will lead to the corresponding sanction on the players in-game or forum account.</strong></p><h3 id="h_59441496135081658239418048"><a title="Naming Policy" href="#h_59441496135081658239418048"><span style="color: #f8b700;">#</span></a> A. Naming policy</h3><hr><p>When choosing a character name, creating a guild, or otherwise creating a label that can be seen by other users using the Game or the service, you must abide by the guidelines set forth here, as well as the rules of common decency.</p><p>If YesilCMS PTR staff finds such a label to be offensive or inappropriate, it may, in its sole and absolute discretion, change the name, remove the label and corresponding chat room, and/or suspend or terminate your use of the service. Guilds which violate the policy will be deleted with or without warning.</p><p><strong>You may not create a name or label related, referring, incorporates or utilizes any of the following:</strong></p><ul><li>Religion, Politics, Organizations;</li><li>Nationality, Racism, Ethnics;</li><li>Harassment or Defamation;</li><li>Obscenity, Vulgarity, Insults;</li><li>Sexually explicit, Violence;</li><li>Hateful, Drugs, Unlawful;</li><li>Staff member or any staff oriented name;</li><li>Incomprehensible.</li></ul><h3 id="h_99639913838171658239432028"><a title="Interacting with players and staff" href="#h_99639913838171658239432028"><span style="color: #f8b700;">#</span></a> B. Interacting with players and staff</h3><hr><p>Communicating in-game with other users and staff members, whether by text or any other method, is a fundamental element of the Game. The following rules are not intended to be exhaustive. YesilCMS PTR staff may use their discretion to decide what may break these rules.</p><p><strong>When communicating with other users and staff, you may not:</strong></p><ul><li>Communicate any unlawful, obscene, racist or any such language and/or imagery deemed inappropriate by YesilCMS PTR staff.</li><li>Circumvent the /ignore function to communicate with a user, regardless of circumstances.</li><li>Disrupt any feature of the Game and/or any component thereof in a manner that is deemed negatively on other users, including but not limited to, sending junk mail, repeated unsolicited messages, sending advertisement and/or services for goods or services originating outside the Game.</li><li>Participate in any action that, in the sole and absolute discretion of YesilCMS PTR staff, results or may result in a player being "scammed" or defrauded out of currency or any other items the user has earned.</li><li>Advertise or operate services in-game and/or on the forum which in the sole discretion of YesilCMS PTR staff is considered a casino and/or gambling.</li><li>Send chat messages that has in any way been modified to change the publicly shown color of the respective message.</li><li>Impersonate any user, including without limitation any game master or any other YesilCMS PTR staff member.</li><li>Communicate, post and/or direct users to information regarding a user\'s or staff member\'s identity and/or personal information.</li><li>Institute, assist, threaten, or become involved in an attack upon any YesilCMS PTR service or any of its users in an attempt to disrupt the servers or experience of users.</li><li>Lie to, or attempt to deceive YesilCMS PTR staff.</li><li>Use non-English language in public channels.</li></ul><h3 id="h_35855809242571658239467379"><span style="color: #f8b700;"><a style="color: #f8b700;" title="Gameplay" href="#h_35855809242571658239467379">#</a></span> C. Gameplay</h3><hr><h4 id="h_80154573848391658239482854"><span style="color: #f8b700;"><a style="color: #f8b700;" title="Player vs Player" href="#h_80154573848391658239482854">#</a></span> a). Player vs Player</h4><p>The YesilCMS PTR staff recognizes all play styles to be valid and a part of the game and not harassment. Killing players of your opposing faction, including camping players at spirit healers, corpses and/or gravestones, is considered a part of the game.</p><p>While playing on a Player vs. Player server, you should always remember to protect yourself in zones where the members of a hostile faction can attack you.</p><h4 id="h_40811323351781658239507929"><span style="color: #f8b700;"><a style="color: #f8b700;" title="Streaming / Stream Sniping" href="#h_40811323351781658239507929">#</a></span> b). Streaming / Stream Sniping</h4><p>Streaming on any service is allowed by YesilCMS PTR, however, we encourage you to research the TOU of the streaming service you intend to use in order to protect your streaming account.</p><p>The act of "stream sniping" is not a violation of this agreement as we cannot intervene if someone in-game makes the decision to communicate their every move, thereby informing other users of their position and/or in-game status.</p><h4 id="h_52598274554621658239525398"><a title="Safespotting" href="#h_52598274554621658239525398"><span style="color: #f8b700;">#</span></a> c). Safespotting</h4><p>Safespotting is prohibited under all circumstances. This is the act of engaging in PvP combat while:</p><ul><li>Exploiting a position that cannot be reached by basic jumping (no wall-climbing).</li><li>Being in an advantageous position where an NPC cannot reach you due to pathing or some other game mechanic used as an unintended advantage.</li><li>Being out of the aggro range or line of sight of an NPC is not safespotting except when pathing is exploited to shorten the required distance to aggro the NPC.</li></ul><p>The following are situations which would be considering safespotting:</p><ul><li>Being on an object and in range of a guard that would attack you the moment you stepped off the object.</li><li>Being on various interconnected platforms (rooftops, decks, walkways, etc.) with varied heights and connected pathing that reduces the distance you must be away from an NPC.</li></ul><p>Please note that we will rarely, if ever, intervene inside a battleground for safespotting. The following rooftops are prohibited in battlegrounds and will be considered safespotting:</p><ul><li>Blacksmith (until level 60 battlegrounds)</li><li>Stables</li><li>Lumber Mill</li></ul><h4 id="h_51134838655611658239553111"><span style="color: #f8b700;"><a style="color: #f8b700;" title="Certain behaviour goes beyond what is considered fair and are considered a violation of this agreement." href="#h_51134838655611658239553111">#</a></span> d ). Certain behaviour goes beyond what is considered fair and are considered a violation of this agreement. This behaviour includes, but is not limited to, the following:</h4><ul><li>Using or exploiting errors in design, features, and/or bugs to gain access that is otherwise not available, to facilitate and/or grant you an advantage over other players.</li><li>Engaging players through various world terrain, such as roofs that is otherwise not accessible to gain an advantage.</li><li>Intentionally not participating in a battleground.</li></ul><h3 id="h_71558582156701658239563531"><a title="Griefing" href="#h_71558582156701658239563531"><span style="color: #f8b700;">#</span></a> D. Griefing</h3><hr><p>Players can interact in a variety of ways, not all of them constructive. You may encounter players that steal resource nodes, chests, items, lead monsters to new areas and summon demons that raise havoc.</p><p>YesilCMS PTR staff will not intervene in these situations as the community may take measures concerning these players. However, behaviour that is considered to be contrary to the essence of the Game will be considered a violation of this agreement.</p><p><strong>Such behaviour is considered griefing which includes, but is not limited to, the following:</strong></p><ul><li>Summoning demons at the initial starting zones of new players;</li><li>Intentionally killing or disabling important quest NPCs for an extended period of time;</li><li>Intentionally causing any of the four demons for Stave of the Ancients to despawn;</li><li>Intentionally causing The Cleaner to appear during The Balance of Light and Dark;</li><li>Intentionally interrupting or negatively influencing a raid group that is currently engaged in ANY world boss encounter on the PvP realms with same-faction characters.</li><li>World boss encounters are unique circumstances, and resolution will be determined at the discretion of the attending GM. For same faction on PVP we strongly suggest a first come, first serve mentality when encountering world bosses.</li></ul><h3 id="h_15834439558641658239573401"><span style="color: #f8b700;"><a style="color: #f8b700;" title="Forum" href="#h_15834439558641658239573401">#</a></span> E. Forum</h3><hr><p>YesilCMS PTR can\'t allow all kinds of discussion on the forum. The forum is here to provide you with a friendly environment where you can discuss ideas, give game-play advice, role-play, and converse about any other aspect with other players.</p><p>Community forums work best when participants treat their fellow users with respect, courtesy and common decency. Therefore, please be civilized when participating. YesilCMS PTR staff need to be able to read everything you post to ensure it abides by this agreement.</p><p>Posts not in English are subject to deletion.</p><p><strong>YesilCMS PTR staff reserves the right to delete, move or edit any post with or without warning nor explanation to the user. In extreme cases, YesilCMS PTR staff may limit or block the forum access from a user.</strong></p><h2 id="h_29393716159801658239585177"><span style="color: #f8b700;"><a style="color: #f8b700;" title="Account Information" href="#h_29393716159801658239585177">#</a></span> II. Account Information</h2><hr><p>YesilCMS PTR staff will never ask for your account details or share any confidential information. For the safety of your account, never share any of your account information, such as email addresses, account names, or passwords.</p><h3 id="h_44887166560881658239595972"><span style="color: #f8b700;"><a style="color: #f8b700;" title="Account security" href="#h_44887166560881658239595972">#</a></span> A. Account security</h3><hr><p>The account owner is responsible for the security of the account and that it\'s sufficiently protected. Note that YesilCMS PTR staff does not recover hacked accounts.</p><p><strong>You should:</strong></p><ul><li>Never share your account information;</li><li>Have a unique and complicated password that does not exceed 16 characters;</li><li>Connect yourself from a secure computer and network;</li><li>Never download unsafe files that might contain viruses/malware;</li><li>Never use the same credentials (username and password) on another server or service.</li></ul><h3 id="h_28262252561941658239604545"><span style="color: #f8b700;"><a style="color: #f8b700;" title="Account sharing/trading" href="#h_28262252561941658239604545">#</a></span> B. Account sharing/trading</h3><hr><p>You may not purchase, sell, gift, share, lend, or trade any account. You may not offer to purchase, sell, gift, share, lend, or trade any account. Any such attempt can result in account suspension or closure.</p><p>The only exception to this is a guild bank. To be considered a Guild Bank no character on any server can be above level 5. If a guild chooses to create a shared bank it is at their own risk. No action to investigate, recover or punish anyone for removing any item from a shared guild bank will be taken by the YesilCMS PTR Project. Sharing a guild bank is at your own risk.</p><h3><a href="Forgotten%20your%20password"><span style="color: #f8b700;">#</span></a> C. Forgotten your password</h3><hr><p>Click <a href="#">this link (WIP)</a> to reset your password. This will be available soon. Please note that YesilCMS PTR does not recover lost accounts.</p><h2 id="h_92066435964031658239621307"><span style="color: #f8b700;"><a style="color: #f8b700;" title="Character/Currency/Item restoration" href="#h_92066435964031658239621307">#</a></span> III. Character/Currency/Item restoration</h2><hr><p>YesilCMS PTR staff can\'t guarantee the recovery of any lost or deleted characters. We have a limited ability to restore deleted characters and will do so if possible but it is by no means 100%.</p><p>Game items such as experience, gold or equipment that you have lost through accident, very rare failure of the server, or otherwise, cannot be restored. There are two exceptions to this:</p><p>Unique quest items or keys can be restored with sufficient evidence that the player had previously obtained them.</p><p>Raid items with the rarity of Epic and above can be restored in the case of a server crash/roll-back, providing an in-game ticket is sent to us which fulfills the conditions below:</p><ol style="list-style-type: upper-roman;"><li>Exact date of the raid;</li><li>Video of complete encounter which also shows the raid ID, loot and complete list of raid members;</li><li>Name of the player who received or should have received the item.</li></ol><p>More information regarding item restoration requests can be found in our <a title="FAQ" href="faq">FAQ</a> post regarding item restorations.</p><p><strong>Restoration of any item is always at the discretion of YesilCMS PTR staff. Falsified information will lead to immediate account closure.</strong></p><h2 id="h_33622227565061658239628623"><span style="color: #f8b700;"><a style="color: #f8b700;" title="Misloots" href="#h_33622227565061658239628623">#</a></span> IV. Misloots</h2><hr><p>YesilCMS PTR staff does not handle requests for reassignment of loot from one player to another when the item was accidentally awarded to the wrong player. Players are advised to exercise caution when choosing to roll on items and when master-looting.</p><p>In cases where a misloot occurs due to a bug or system failure, YesilCMS PTR staff may (at our sole discretion), resolve issues with proof (such as screenshots or video) that the item should have been awarded.</p><h2 id="h_34417900166091658239636440"><span style="color: #f8b700;"><a style="color: #f8b700;" title="Cheating/Unlawful" href="#h_34417900166091658239636440">#</a></span> V. Cheating/Unlawful</h2><hr><p>YesilCMS PTR staff may suspend or close any account if you violate, or assist others in violating, the sections set forth below. You agree that you will not, in whole or in part or under any circumstances, do the following.</p><p><strong>Use, offer, advertise and/or distribute the following or assist there in:</strong></p><ul><li>Cheats; methods to influence and/or facilitate the game-play, including exploits of any existing in-game bugs, and thereby granting you and/or any other user an advantage.</li><li>Bots; including, but not limited to, any code, hardware and/or software that allows the automated control of the Game, or any feature or component thereof.</li><li>Hacks; accessing or altering the Game code, memory, packet data, software and/or any component or feature thereof, which changes and/or facilitates the game-play.</li><li>Electronic attacks; methods to block/delay connections, impede bandwidth, fragment packets and/or application or any such attempt to disrupt any YesilCMS PTR server, network and/or service, or any feature or component thereof.</li></ul><h2 id="h_72530331367111658239645831"><span style="color: #f8b700;"><a style="color: #f8b700;" title="Trading Virtual Goods/Services (Real Money Trading/RMT)" href="#h_72530331367111658239645831">#</a></span> VI. Trading Virtual Goods/Services (Real Money Trading/RMT)</h2><hr><p>YesilCMS PTR does not condone the trade of virtual goods or services appearing or originating from the Game, or any other attributes associated with an account or any component thereof for real money, or exchange those items, currencies or services for value outside of the Game.</p><p><em><strong>YesilCMS PTR staff reserves the right to close any account involved in such transaction.</strong></em></p><h2 id="h_61543306168111658239652578"><span style="color: #f8b700;"><a style="color: #f8b700;" title="Multiboxing" href="#h_61543306168111658239652578">#</a></span> VII. Multiboxing</h2><hr><p>Multiboxing is not allowed and refers to playing multiple characters simultaneously, regardless of whether this is done via 3rd party software, alt-tabbing between instances, or by running multiple machines.</p><p>The only exception is that you may have two characters of the same faction in any non-hostile city with an Auction House. This may not be used to gain an advantage in PvP situations.</p><p>In situations where a player is found to have 3 or more instances active at any given time, the sanction can be increased up to a permanent ban at the discretion of YesilCMS PTR\'s staff.</p><h2 id="h_96604790269221658239661289"><a title="Staff Assistance" href="#h_96604790269221658239661289"><span style="color: #f8b700;">#</span></a> VIII. Staff Assistance</h2><hr><p>We do understand that a player who\'s contacting the YesilCMS PTR staff might be upset over an issue they experienced within the Game. However, the use of vulgar, abusive or disrespectful language towards staff members is unnecessary, inappropriate and unproductive.</p><p>Players who engage in this behaviour will be told to stop, if they continue, a sanction may be placed on the account. A staff member will never ask you to do anything that would compromise an account or its personal information.</p><p>YesilCMS PTR staff will make every attempt to show you the respect you deserve. We ask that you show us the same respect. We take no joy in placing sanctions on an account, but must do so in accordance with this agreement.</p><h3 id="h_36358683370101658239668929"><a title="In-game assistance" href="#h_36358683370101658239668929"><span style="color: #f8b700;">#</span></a> A. In-game assistance</h3><hr><p>You can access the in-game ticket system by clicking on the red question mark located to the right in the interface bar. Keep in mind that if a staff member is unable to reach you in-game or if the issue does not require further information, the staff member will respond with an in-game mail.</p><p><strong>Before using this feature:</strong></p><ul><li>If your issue is related to a quest, abandon it and reacquire it;</li><li>If you are experiencing any bugs, disable all add-ons and restart the game;</li><li>Clean out the game cache by deleting the WDB folder within the Game directory;</li><li>Speak with other players to see if they already faced the same problem and how they solved it.</li></ul><p><strong>Requests that will not be processed which are not necessarily limited to, the following:</strong></p><ul><li>Incomprehensible requests;</li><li>Requests for items and/or currency;</li><li>Ban requests for players and/or accounts;</li><li>Information and/or help for a quest;</li><li>Bug reports: Please use our public Bug Tracker for any bug reports so that the QA team can verify and reproduce the bug and forward it to the developers;</li><li>Requests not related to the server where the ticket was created.</li></ul><h3 id="h_34047401871001658239679914"><a title="Forum assistance" href="#h_34047401871001658239679914"><span style="color: #f8b700;">#</span></a> B. Forum assistance</h3><hr><p>Please direct all help request related questions to the support section on the forum. If you believe a user has violated this agreement, please report the user by clicking on their forum name and then clicking Report this member.</p><h3 id="h_15395205971961658239687669"><span style="color: #f8b700;"><a style="color: #f8b700;" title="Staff member interaction" href="#h_15395205971961658239687669">#</a></span> C. Staff member interaction</h3><hr><p>Time spent processing issues that has already been answered keeps the YesilCMS PTR staff from addressing other users pressing issues. If a single player repeatedly creates abusive or multiple tickets and/or reports regarding the same closed issue, or otherwise misuse the respective system, they will be asked to stop, and if ignored, they will receive a sanction on their account.</p><p>Any attempt to bribe an YesilCMS PTR staff member will result in an immediate sanction being placed on the account.</p><p><strong>YesilCMS PTR reserves the right, at its sole and absolute discretion, to change, modify, add to, supplement or delete, at any time, any of the terms and conditions of this Agreement. Effective with or without prior notice to you.</strong></p><h2 id="h_71960829772991658239695009"><span style="color: #f8b700;"><a style="color: #f8b700;" title="Sanctions" href="#h_71960829772991658239695009">#</a></span> IX. Sanctions</h2><hr><p>Any sanctions or warnings previously set on an account are taken into consideration should the account be found in violation of the ToU. Throw-away accounts in violation of the rules are always permanently banned. Some sanctions can be applied without previous warning. This will depend on its seriousness.</p><p>e.g. A player spamming any public channel should receive a warning. If the spam is found to be excessive the Game Master can decide to bypass the warning and give the player a temporary mute.</p><h3 id="h_3679796774051658239703509"><span style="color: #f8b700;"><a style="color: #f8b700;" title="Warning" href="#h_3679796774051658239703509">#</a></span> A. Warning</h3><hr><p>For minor infringements, a warning is first given to inform a player about the rules and warn him about future sanctions. Warnings remain in the players record.</p><p>Spam;</p><ul><li>AFK in BGs;</li><li>Extensive killing of important quest NPCs;</li><li>Player harassment (including same faction griefing with no in-game counter);</li><li>Racist or offensive sentiments;</li><li>Using color changing scripts in-game;</li><li>Abuse of assistance system (forum or in-game);</li><li>Safespotting;</li><li>Lack of respect towards the server or the staff members;</li><li>Multiboxing;</li><li>Any attempt to bribe a staff member;</li><li>Non-English language in public channels.</li></ul><h3 id="h_98059881875051658239710906"><span style="color: #f8b700;"><a style="color: #f8b700;" title="Mute or temporary account interruption" href="#h_98059881875051658239710906">#</a></span> B. Mute or temporary account interruption</h3><hr><p>This sanction can last anywhere from 3 hours to 30 days, depending on severity, and is given for repeated violation of the rules, or for any of the following:</p><ul><li>Scamming;</li><li>Lying to, or attempting to deceive YesilCMS PTR staff;</li><li>Abuse of in-game bugs;</li><li>Organized killing for farming rank and/or honor;</li><li>Same faction griefing on world bosses;</li><li>Tagging a world boss and having the other faction kill it for you.</li></ul><h3 id="h_49439111276081658239719160"><span style="color: #f8b700;"><a style="color: #f8b700;" title="Permanent ban" href="#h_49439111276081658239719160">#</a></span> C. Permanent ban</h3><hr><p>The most serious sanction. This sanction is applied in case of multiple violations of the rules, or after multiple account interruptions, as well as any of the following:</p><ul><li>COD Scamming;</li><li>Hacking;</li><li>Using any means of botting (e.g. a program);</li><li>Any client modification (libraries, executables, MPQ, etc.);</li><li>Revealing the identity of a YesilCMS PTR staff member;</li><li>Advertising for other private servers or gold selling websites;</li><li>Selling/Buying player names;</li><li>Exchanging accounts, gold, items, or any ingame services for another game\'s features;</li><li>Selling/Buying accounts, gold, items, or any ingame services with real money;</li><li>Possession of any item(s) or currencies obtained with illegal methods;</li><li>Publishing software, methods or articles on cheating which can be applied on the server;</li><li>Abuse of major in-game bugs;</li><li>Staff impersonation.</li></ul><p><strong>YesilCMS PTR reserves the right, in its sole and absolute discretion, to increase a sanction, suspend or terminate your use of the service at any time, for any reason or for no reason, with or without prior notice to you.</strong></p>',
            'date'         => '1659139200',
        );
        $this->db->insert('pages', $data);
    }

    public function down()
    {
        $this->dbforge->drop_table('pages');
    }
}
